<?php

$paramArray[1] = Array(
				"listTitle" => "职称管理",	//列表标题
				"pageTitle" => "职称管理",	//页面标题
				"addTitle" => "增加职称",	//增加页面标题
				"editTitle" => "修改职称",	//修改页面标题
				"mainFieldTitle" => "职称名称",	//主要字段名称
				"tableName" => "object_job_title",		//表名
				"checkboxTitle" => "&nbsp;职称：",		//选择框前的文字
				"checkboxName" => "job_title[]",
				"checkboxTableId" => "job_title_table"
				);
				
$paramArray[2] = Array(
				"listTitle" => "学历管理",	//列表标题
				"pageTitle" => "学历管理",	//页面标题
				"addTitle" => "增加学历",	//增加页面标题
				"editTitle" => "修改学历",	//修改页面标题
				"mainFieldTitle" => "学历名称",	//主要字段名称
				"tableName" => "object_education_title",		//表名
				"checkboxTitle" => "&nbsp;学历：",		//选择框前的文字
				"checkboxName" => "education_title[]",
				"checkboxTableId" => "education_title_table"
				);
				
$paramArray[3] = Array(
				"listTitle" => "单位管理",	//列表标题
				"pageTitle" => "单位管理",	//页面标题
				"addTitle" => "增加单位信息",	//增加页面标题
				"editTitle" => "修改单位信息",	//修改页面标题
				"mainFieldTitle" => "单位名称",	//主要字段名称
				"tableName" => "object_company_title",		//表名
				"checkboxTitle" => "&nbsp;所属单位：",		//选择框前的文字
				"checkboxName" => "company_title[]",
				"checkboxTableId" => "company_title_table"
				);
				
$paramArray[4] = Array(
				"listTitle" => "条文释义分类管理",	//列表标题
				"pageTitle" => "条文释义分类管理",	//页面标题
				"addTitle" => "增加条文释义分类",	//增加页面标题
				"editTitle" => "修改条文释义分类",	//修改页面标题
				"mainFieldTitle" => "条文释义分类名称",	//主要字段名称
				"tableName" => "object_main_type_title",		//表名
				"checkboxTitle" => "条文释义分类：",		//选择框前的文字
				"checkboxName" => "main_type_title[]",
				"checkboxTableId" => "main_type_title_table"
				);
				
$paramArray[5] = Array(
				"listTitle" => "法律实务分类管理",	//列表标题
				"pageTitle" => "法律实务分类管理",	//页面标题
				"addTitle" => "增加法律实务",	//增加页面标题
				"editTitle" => "修改法律实务",	//修改页面标题
				"mainFieldTitle" => "法律实务名称",	//主要字段名称
				"tableName" => "object_law_type_title",		//表名
				"checkboxTitle" => "法律实务分类：",		//选择框前的文字
				"checkboxName" => "law_type_title[]",
				"checkboxTableId" => "law_type_title_table"
				);
				
$paramArray[6] = Array(
				"listTitle" => "效力分类管理",	//列表标题
				"pageTitle" => "效力分类管理",	//页面标题
				"addTitle" => "增加效力分类",	//增加页面标题
				"editTitle" => "修改效力分类",	//修改页面标题
				"mainFieldTitle" => "效力分类名称",	//主要字段名称
				"tableName" => "object_positive_title",		//表名
				"checkboxTitle" => "&nbsp;所属效力：",		//选择框前的文字
				"checkboxName" => "positive_title[]",
				"checkboxTableId" => "positive_title_table"
				);
				
$paramArray[7] = Array(
				"listTitle" => "地域管理",	//列表标题
				"pageTitle" => "地域管理",	//页面标题
				"addTitle" => "增加地域",	//增加页面标题
				"editTitle" => "修改地域",	//修改页面标题
				"mainFieldTitle" => "地域名称",	//主要字段名称
				"tableName" => "object_city_title",		//表名
				"checkboxTitle" => "&nbsp;所属地域：",		//选择框前的文字
				"checkboxName" => "city_title[]",
				"checkboxTableId" => "city_title_table"
				);
				
$paramArray[8] = Array(
				"listTitle" => "颁布部门分类管理",	//列表标题
				"pageTitle" => "颁布部门分类管理",	//页面标题
				"addTitle" => "增加颁布部门分类",	//增加页面标题
				"editTitle" => "修改颁布部门分类",	//修改页面标题
				"mainFieldTitle" => "颁布部门分类名称",	//主要字段名称
				"tableName" => "object_department_title",		//表名
				"checkboxTitle" => "颁布部门分类：",		//选择框前的文字
				"checkboxName" => "department_title[]",
				"checkboxTableId" => "department_title_table"
				);
				
$paramArray[9] = Array(
				"listTitle" => "法律专业类别管理",	//列表标题
				"pageTitle" => "法律专业类别管理",	//页面标题
				"addTitle" => "增加法律专业类别",	//增加页面标题
				"editTitle" => "修改法律专业类别",	//修改页面标题
				"mainFieldTitle" => "法律专业类别名称",	//主要字段名称
				"tableName" => "object_law_specialized_title",		//表名
				"checkboxTitle" => "法律专业类别：",		//选择框前的文字
				"checkboxName" => "law_specialized_title[]",
				"checkboxTableId" => "law_specialized_title_table"
				);
				
$paramArray[10] = Array(
				"listTitle" => "院校类别管理",	//列表标题
				"pageTitle" => "院校类别管理",	//页面标题
				"addTitle" => "增加院校类别",	//增加页面标题
				"editTitle" => "修改院校类别",	//修改页面标题
				"mainFieldTitle" => "院校类别名称",	//主要字段名称
				"tableName" => "object_school_type_title",		//表名
				"checkboxTitle" => "&nbsp;院校类别：",		//选择框前的文字
				"checkboxName" => "school_type_title[]",
				"checkboxTableId" => "school_type_title_table"
				);
				
$paramArray[11] = Array(
				"listTitle" => "院校专业管理",	//列表标题
				"pageTitle" => "院校专业管理",	//页面标题
				"addTitle" => "增加院校专业",	//增加页面标题
				"editTitle" => "修改院校专业",	//修改页面标题
				"mainFieldTitle" => "院校专业名称",	//主要字段名称
				"tableName" => "object_school_specialized_title",		//表名
				"checkboxTitle" => "&nbsp;院校专业：",		//选择框前的文字
				"checkboxName" => "school_specialized_title[]",
				"checkboxTableId" => "school_specialized_title_table"
				);
				
$paramArray[12] = Array(
				"listTitle" => "公检司法类别管理",	//列表标题
				"pageTitle" => "公检司法类别管理",	//页面标题
				"addTitle" => "增加公检司法类别",	//增加页面标题
				"editTitle" => "修改公检司法类别",	//修改页面标题
				"mainFieldTitle" => "公检司法类别名称",	//主要字段名称
				"tableName" => "object_gjsf_type_title",		//表名
				"checkboxTitle" => "&nbsp;公检司法类别：",		//选择框前的文字
				"checkboxName" => "gjsf_type_title[]",
				"checkboxTableId" => "gjsf_type_title_table"
				);
				
$paramArray[13] = Array(
				"listTitle" => "法律学人分类管理",	//列表标题
				"pageTitle" => "法律学人分类管理",	//页面标题
				"addTitle" => "增加法律学人分类",	//增加页面标题
				"editTitle" => "修改法律学人分类",	//修改页面标题
				"mainFieldTitle" => "法律学人分类名称",	//主要字段名称
				"tableName" => "object_lawer_type_title",		//表名
				"checkboxTitle" => "&nbsp;法律学人分类：",		//选择框前的文字
				"checkboxName" => "lawer_type_title[]",
				"checkboxTableId" => "lawer_type_title_table"
				);
				
$paramArray[14] = Array(
				"listTitle" => "WTO动态分类管理",	//列表标题
				"pageTitle" => "WTO动态分类管理",	//页面标题
				"addTitle" => "增加WTO动态分类",	//增加页面标题
				"editTitle" => "修改WTO动态分类",	//修改页面标题
				"mainFieldTitle" => "WTO动态分类名称",	//主要字段名称
				"tableName" => "object_wto_info_type_title",		//表名
				"checkboxTitle" => "&nbsp;WTO动态分类：",		//选择框前的文字
				"checkboxName" => "wto_info_type_title[]",
				"checkboxTableId" => "wto_info_type_title_table"
				);
				
$paramArray[15] = Array(
				"listTitle" => "案件状态管理",	//列表标题
				"pageTitle" => "案件状态管理",	//页面标题
				"addTitle" => "增加案件状态",	//增加页面标题
				"editTitle" => "修改案件状态",	//修改页面标题
				"mainFieldTitle" => "案件状态名称",	//主要字段名称
				"tableName" => "object_case_status_title",		//表名
				"checkboxTitle" => "&nbsp;案件状态：",		//选择框前的文字
				"checkboxName" => "wto_case_status_title[]",
				"checkboxTableId" => "wto_case_status_title_table"
				);
				
$paramArray[16] = Array(
				"listTitle" => "考研资讯分类管理",	//列表标题
				"pageTitle" => "考研资讯分类管理",	//页面标题
				"addTitle" => "增加考研资讯分类",	//增加页面标题
				"editTitle" => "修改考研资讯分类",	//修改页面标题
				"mainFieldTitle" => "考研资讯分类名称",	//主要字段名称
				"tableName" => "object_kaoyan_info_type_title",		//表名
				"checkboxTitle" => "&nbsp;所属资讯分类：",		//选择框前的文字
				"checkboxName" => "kaoyan_info_type_title[]",
				"checkboxTableId" => "kaoyan_info_type_title_table"
				);
				
$paramArray[17] = Array(
				"listTitle" => "营销知识分类管理",	//列表标题
				"pageTitle" => "营销知识分类管理",	//页面标题
				"addTitle" => "增加营销知识分类",	//增加页面标题
				"editTitle" => "修改营销知识分类",	//修改页面标题
				"mainFieldTitle" => "营销知识分类名称",	//主要字段名称
				"tableName" => "object_yingxiaozhishi_type_title",		//表名
				"checkboxTitle" => "&nbsp;所属营销知识分类：",		//选择框前的文字
				"checkboxName" => "yingxiaozhishi_type_title[]",
				"checkboxTableId" => "yingxiaozhishi_type_title_table"
				);
				
$paramArray[18] = Array(
				"listTitle" => "合同种类管理",	//列表标题
				"pageTitle" => "合同种类管理",	//页面标题
				"addTitle" => "增加合同种类",	//增加页面标题
				"editTitle" => "修改合同种类",	//修改页面标题
				"mainFieldTitle" => "合同种类名称",	//主要字段名称
				"tableName" => "object_contract_type",		//表名
				"checkboxTitle" => "&nbsp;所属合同种类：",		//选择框前的文字
				"checkboxName" => "contract_type_title[]",
				"checkboxTableId" => "contract_type_title_table"
				);
				
$paramArray[19] = Array(
				"listTitle" => "案件专题管理",	//列表标题
				"pageTitle" => "案件专题管理",	//页面标题
				"addTitle" => "增加案件专题",	//增加页面标题
				"editTitle" => "修改案件专题",	//修改页面标题
				"mainFieldTitle" => "案件专题名称",	//主要字段名称
				"tableName" => "object_case_type",		//表名
				"checkboxTitle" => "&nbsp;所属案件专题：",		//选择框前的文字
				"checkboxName" => "case_type_title[]",
				"checkboxTableId" => "case_type_title_table"
				);

$gen = $_GET['gen'];
if($gen == '1'){
	for($i = 1; $i <= count($paramArray); $i++){
		$createSql = "CREATE TABLE IF NOT EXISTS ".$paramArray[$i]['tableName']." (
					  id int(11) unsigned NOT NULL AUTO_INCREMENT,
					  val varchar(100) CHARACTER SET utf8 NOT NULL,
					  status tinyint(1) NOT NULL,
					  PRIMARY KEY (`id`)
					) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;";
		echo $createSql . '<br>';
	}
}
				
/*
DROP TABLE IF EXISTS `article_options_mapping`;
CREATE TABLE IF NOT EXISTS `article_options_mapping` (
  `id` int(4) unsigned NOT NULL AUTO_INCREMENT,
  `article_id` int(4) NOT NULL,
  `option_keyname` varchar(50) CHARACTER SET utf8 NOT NULL,
  `option_value` int(4) NOT NULL,
  `article_title` varchar(255) CHARACTER SET utf8 NOT NULL,
  `topicid` int(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

DELETE FROM `youisinc_law`.`cms_arcatt` WHERE `cms_arcatt`.`att` = 's';
DELETE FROM `youisinc_law`.`cms_arcatt` WHERE `cms_arcatt`.`att` = 'f';
DELETE FROM `youisinc_law`.`cms_arcatt` WHERE `cms_arcatt`.`att` = 'j';
DELETE FROM `youisinc_law`.`cms_arcatt` WHERE `cms_arcatt`.`att` = 'a';

*/
?>